הצגת המקור של הדף "כדורעף:משחקים עם מערכות לא נכונות"

{{#cargo_query:
tables=Volleyball_Games
|fields=_pageName, TotalSetsMaccabi=MaccabiSetsWritten, 
(COALESCE(FirstSetPointsMaccabi, 0) > COALESCE(FirstSetPointsOpponent, 0)) +
(COALESCE(SecondSetPointsMaccabi, 0) > COALESCE(SecondSetPointsOpponent, 0)) +
(COALESCE(ThirdSetPointsMaccabi, 0) > COALESCE(ThirdSetPointsOpponent, 0)) +
(COALESCE(FourthSetPointsMaccabi, 0) > COALESCE(FourthSetPointsOpponent, 0)) +
(COALESCE(FifthSetPointsMaccabi, 0) > COALESCE(FifthSetPointsOpponent, 0)) = MaccabiSetsCalculated
|where=1=1
AND TotalSetsMaccabi != 
  ( (COALESCE(FirstSetPointsMaccabi, 0) > COALESCE(FirstSetPointsOpponent, 0)) +
    (COALESCE(SecondSetPointsMaccabi, 0) > COALESCE(SecondSetPointsOpponent, 0)) +
    (COALESCE(ThirdSetPointsMaccabi, 0) > COALESCE(ThirdSetPointsOpponent, 0)) +
    (COALESCE(FourthSetPointsMaccabi, 0) > COALESCE(FourthSetPointsOpponent, 0)) +
    (COALESCE(FifthSetPointsMaccabi, 0) > COALESCE(FifthSetPointsOpponent, 0)) )
AND FirstSetPointsMaccabi IS NOT NULL
|format=dynamic table
|rows per page=100
|order by=Volleyball_Games.Date DESC
}}


[[קטגוריה:עמודי מעקב למשחקי כדורעף]]